package cn.com.shopec.erp.product.dao;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.springframework.stereotype.Repository;

import cn.com.shopec.erp.common.orm.impl.HibernateEntityDao;
import cn.com.shopec.erp.product.entity.ProdSpecValue;

/** 
 * @ClassName: ProdSpecValueDaoImpl 
 * @Description: 货品的规格值表的dao实现
 *  
 */
@Repository
public class ProdSpecValueDaoImpl extends HibernateEntityDao<ProdSpecValue> implements IProdSpecValueDao {

	@Override
	public void deleteProdSpecValue(String prodNo) {
		try {
			Query query = this.createSQLQuery("delete from TBL_PROD_SPEC_VALUE where PROD_NO='" + prodNo + "'");
			query.executeUpdate();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
	}

}
